package com.example.attempt.mapper;

import com.example.attempt.entity.Student;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface StudentMapper {
    public List<Student> queryAll();
    public Student queryById(String sid); //根据用户名查询数据
    public List<Student> queryByName(String sname);
    public Student queryByIdAndP(String sid, String spwd);
    public int getNum();
    public void deleteStudent(String sid);
    public int addStudent(Student student); //添加数据
}
